Stored Procedures [dbo].[BAEEventSetupAddQuestion]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@eventCodevarchar(15)15
@functionCodevarchar(15)15
@questionvarchar(255)255
@questionTypevarchar(30)30
@requiredbit1
@questionorderint4
SQL Script
create procedure [dbo].[BAEEventSetupAddQuestion] @eventCode varchar(15),
     @functionCode varchar(15),
     @question varchar(255),
     @questionType varchar(30),
     @required bit,
     @questionorder int as
INSERT INTO EventSetupQuestion(EventCode, FunctionCode, Question,  QuestionType, Required,  QuestionOrder)
    VALUES(@eventCode, @functionCode, @question,  @questionType, @required, @questionorder);

    SELECT CAST(@@IDENTITY AS INT);

GO
Uses